package top.shiyiri.shops.dao;

import top.shiyiri.shops.bean.ProTotalCount;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;


import java.util.List;

/**
 * @author Aunean
 * @date 2021/12/28
 */
public interface ProTotalCountDao {

    @Select("select * from pro_total_count limit #{begin}, #{size}")
    List<ProTotalCount> proTotalCountByPage(@Param("begin") int begin, @Param("size") int size);

    @Select("select count(*) from pro_total_count")
    int totalLine();

    @Select("select * from pro_total_count")
    List<ProTotalCount> proTotalCount();

    @Select("select * from pro_total_count ORDER BY parchaseCount desc LIMIT 10")
    List<ProTotalCount> proTotalCount2();
}
